<%@ page language="java" pageEncoding="UTF-8"%>
<%@page import="java.util.List"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page import="my.market.jdbc.dao.*" %>
<%@ page import="my.market.jdbc.dataClass.*" %>

<%	GoodsDao gd = new GoodsDao();
	List<Goods> goods = (List<Goods>) gd.searchAll(); %>
<html>
<body>
<p align="left">销量统计<br/><br/><br/></p>
<table>
	<tr>
		<td align="center" width="24%">商品编号</td>
		<td align="center" width="18%">商品名称</td>
		<td align="center" width="9%">销量统计</td>
	</tr>
	<c:forEach var="good" items="<%=goods %>" >
		<tr onmouseover="this.style.backgroundColor = 'white'"
			onmouseout="this.style.backgroundColor = '#F5FAFE';">
			<td style="CURSOR: hand; HEIGHT: 22px" align="center" width="200">${good.getId() }</td>
			<td style="CURSOR: hand; HEIGHT: 22px" align="center" width="18%">${good.getName() }</td>
			<td style="CURSOR: hand; HEIGHT: 22px" align="center" width="8%">${good.getSalesnum() }</td>
		</tr>
	</c:forEach>
	<tr>
		<td><a href="${pageContext.request.contextPath}/back_end/display/orders.jsp"><button type="button">返回</button></a>
	</tr>
</table>
</body>
</html>